Learn to handle messy datasets, analyse business questions and communicate clear insights. Build practical skills in Excel, SQL and Power BI, then bring them together in a supported capstone project.
Register for Data AnalyticsBuild the technical discipline and attention to detail needed to work with real-world data. Progress from foundations and cleaning to analysis, interactive dashboards, visual storytelling and executive-ready reporting.
Six weeks of core delivery give you time to practise each skill. The final two weeks focus on one end-to-end project, instructor support, presentation and structured review.
Expand each week to explore session topics, activities and deliverables.
Explore data in education, banking, retail and healthcare. Understand analytics and the four types: descriptive, diagnostic, predictive and prescriptive; compare descriptive and predictive analytics.
Understand rows, columns and datasets; identify String, Integer, Float and Date types. Import CSV datasets into Excel and Google Sheets.
Explore a real dataset, label column types and explain what each row represents. Complete a concepts quiz and submit a one-page dataset profile with dimensions, column types and a potential data issue.
Spot missing values, duplicate records, inconsistent formats, extra spaces and wrong data types. Explain how dirty data leads to inaccurate reports and poor decisions.
Remove duplicates; use TRIM, Text-to-Columns and Find and Replace. Handle missing values by removing, replacing, filling or labelling them. Keep backups, validate types and document changes.
Complete The Great Cleanup: transform a messy CSV into a usable table. Take a cleaning quiz, submit a cleaning log and identify three business questions the dataset can answer.
Apply SUM, AVERAGE, COUNT and COUNTA. Categorise data with IF and Nested IF; calculate conditional totals with SUMIF and COUNTIF.
Build Pivot Tables using Rows, Columns, Values and Filters. Group dates, number ranges and categories; create Pivot Charts to reveal trends.
Build a Monthly Sales Report covering sales by month and shopping mall, and best-performing products by gender. Complete a quiz and extract three specific insights from a retail dataset.
Understand databases and tables linked by common fields. Learn PostgreSQL, SQL syntax and naming conventions; write SELECT, FROM and WHERE queries.
Sort with ORDER BY (ASC and DESC), group with GROUP BY, and use COUNT(), SUM(), AVG(), MIN() and MAX(), including how they treat NULL values.
Query top-performing products and complete a syntax quiz. Answer five business questions: total customers, total revenue, average sales amount, top-selling products and highest-performing region.
Use visuals to simplify complexity, reveal trends and outliers, and support decisions. Choose bar, column, line, pie, donut or scatter charts. Compare Power BI with Excel, including transformation, DAX and dataset size.
Connect data with Get Data, Power Query, and Close and Apply. Build charts, KPI cards, tables, filters and slicers. Keep metrics focused and colours and fonts consistent.
Apply the F-Pattern: top section, second horizontal section, left vertical section and main content. Build a one-page sales dashboard with KPI cards and slicers, and complete a visualization quiz.
Translate data into plain English. Distinguish a finding, an observation and an actionable insight, using the sales growth from $2M to $3M example. Connect insights to decisions.
Storyboard before building. Check data accuracy, visual selection, layout, formatting, colours, interactivity, titles and labels. Introduce Context, Findings, Recommendation (CFR).
Choose a capstone dataset and define the problem, its importance and the information needed. Create one Hero Visual and submit a one-page proposal with the dataset, problem statement and three business questions.
Obtain proposal sign-off and review project rules. Import, profile and clean a raw dataset using Excel or SQL; begin exploratory analysis against your business questions.
Complete analysis with formulas, Pivot Tables or SQL queries. Build your dashboard in Power BI, Tableau or Excel using the approved storyboard.
Review milestones, data accuracy and cleaning logic with instructor support. Share cleaned data and draft analysis, gather peer feedback and create an action list for Week 8.
Apply the seven-step finalisation checklist. Draft slides covering Title, Business Context, Dashboard Overview, Key Findings, Recommendations and Conclusion. Rehearse with peer feedback.
Deliver a live demo or recorded project walkthrough. Instructors assess the project using the capstone rubric.
Revise Weeks 1–6, discuss common mistakes and take part in Q&A. Complete the review quiz, receive capstone feedback, and explore portfolio tips and next learning steps.
Practise the analytics workflow and complete a project that turns business questions into clear recommendations.
Proceed to Registration